{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Graf Dinam x Marca","Graf Dinam x Depto","DATOS","TABLAS","ENUNCIADO","Hoja1"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":2},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Graf Dinam x Marca","index":0,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["NOMAPECIUD","(Todas)"]
[]
["Suma de TOTAL","Etiquetas de columna"]
["Etiquetas de fila","ARMENIA","CARTAGO","MANIZALES","PEREIRA","(en blanco)","Total general"]
["CHEVROLET",null,null,null,186000000,null,186000000]
["FORD",null,null,null,10100000,null,10100000]
["MAZDA",68400000,45600000,7680000,59500000,null,181180000]
["RENAULT",8080000,null,95200000,null,null,103280000]
["(en blanco)",null,null,null,0,0,0]
["Total general",76480000,45600000,102880000,255600000,0,480560000]

{"sheet":"Graf Dinam x Depto","index":1,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["MARCA","(Todas)"]
[]
["Etiquetas de fila","Suma de TOTAL"]
[null,0]
["CALDAS",102880000]
["QUINDIO",76480000]
["RISARALDA",255600000]
["VALLE",45600000]
["Total general",480560000]

{"sheet":"DATOS","index":2,"n_rows":21,"n_cols":19,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["CONSTANTES","PLACA","MARCA","NOMBRES","APELLIDOS","CIUDAD","NOMAPECIUD","DPTO","PRECIO","IVA","VALOR IVA","RET","VALOR RET","MODALIDAD","DSCTO","VALOR DSCTO","SEMAFORIZACION","VALOR SEMAFOR","TOTAL"]
["IVA","ABC123","MAZDA","JUAN PABLO","GARCIA OROZCO","MANIZALES",{"$f":"CONCATENATE(D2,\" \",E2,\" (\",F2,\")\")","v":"JUAN PABLO GARCIA OROZCO (MANIZALES)"},{"$f":"IF(F2=\"\",\"\",VLOOKUP(F2,CIUDADESYDEP,2,FALSE))","v":"CALDAS"},8000000,{"$f":"IF(I2>$A$7,$A$3,0)","v":0},{"$f":"I2*(J2/100)","v":0},{"$f":"IF(F2=$A$9,$A$5,0)","v":0},{"$f":"I2*L2/100","v":0},"Público",{"$f":"IF(C2=$A$13,5,IF(C2=$A$14,5,0))","v":5},{"$f":"I2*O2/100","v":400000},{"$f":"IF(I2<=$A$19,$A$16,IF(I2<=$A$20,$A$17,$A$18))","v":1},{"$f":"I2*Q2/100","v":80000},{"$f":"I2+K2+M2-P2+R2","v":7680000}]
[16,"HH78","MAZDA","MARTHA","GONZALEZ PINEDA","PEREIRA",{"$f":"CONCATENATE(D3,\" \",E3,\" (\",F3,\")\")","v":"MARTHA GONZALEZ PINEDA (PEREIRA)"},{"$f":"IF(F3=\"\",\"\",VLOOKUP(F3,CIUDADESYDEP,2,FALSE))","v":"RISARALDA"},50000000,{"$f":"IF(I3>$A$7,$A$3,0)","v":16},{"$f":"I3*(J3/100)","v":8000000},{"$f":"IF(F3=$A$9,$A$5,0)","v":5},{"$f":"I3*L3/100","v":2500000},"Público",{"$f":"IF(C3=$A$13,5,IF(C3=$A$14,5,0))","v":5},{"$f":"I3*O3/100","v":2500000},{"$f":"IF(I3<=$A$19,$A$16,IF(I3<=$A$20,$A$17,$A$18))","v":3},{"$f":"I3*Q3/100","v":1500000},{"$f":"I3+K3+M3-P3+R3","v":59500000}]
["RET","PEU896","RENAULT","LUIS","LOPEZ","ARMENIA","LUIS LOPEZ (ARMENIA)",{"$f":"IF(F4=\"\",\"\",VLOOKUP(F4,CIUDADESYDEP,2,FALSE))","v":"QUINDIO"},8000000,0,0,0,0,"Particular",0,0,1,80000,8080000]
[5,"MM455","CHEVROLET","ADRIANA","OSPINA ARIAS","PEREIRA","ADRIANA OSPINA ARIAS (PEREIRA)",{"$f":"IF(F5=\"\",\"\",VLOOKUP(F5,CIUDADESYDEP,2,FALSE))","v":"RISARALDA"},150000000,16,24000000,5,7500000,"Público",0,0,3,4500000,186000000]
["TOPE IVA","OLP456","MAZDA","ALONSO","MORALES","CARTAGO","ALONSO MORALES (CARTAGO)",{"$f":"IF(F6=\"\",\"\",VLOOKUP(F6,CIUDADESYDEP,2,FALSE))","v":"VALLE"},40000000,16,6400000,0,0,"Particular",5,2000000,3,1200000,45600000]
[13000000,"MMM45","FORD","JUAN PABLO","GARCIA OROZCO","PEREIRA","JUAN PABLO GARCIA OROZCO (PEREIRA)",{"$f":"IF(F7=\"\",\"\",VLOOKUP(F7,CIUDADESYDEP,2,FALSE))","v":"RISARALDA"},10000000,0,0,5,500000,"Público",5,500000,1,100000,10100000]
["CIUDAD RETENCION","POI89","MAZDA","LUIS","LOPEZ","ARMENIA","LUIS LOPEZ (ARMENIA)",{"$f":"IF(F8=\"\",\"\",VLOOKUP(F8,CIUDADESYDEP,2,FALSE))","v":"QUINDIO"},60000000,16,9600000,0,0,"Particular",5,3000000,3,1800000,68400000]
["PEREIRA","UIY89","RENAULT","ADRIANA","OSPINA ARIAS","MANIZALES","ADRIANA OSPINA ARIAS (MANIZALES)",{"$f":"IF(F9=\"\",\"\",VLOOKUP(F9,CIUDADESYDEP,2,FALSE))","v":"CALDAS"},80000000,16,12800000,0,0,"Público",0,0,3,2400000,95200000]
[null,null,null,null,null,null,"  ()",{"$f":"IF(F10=\"\",\"\",VLOOKUP(F10,CIUDADESYDEP,2,FALSE))","v":""},null,0,0,0,0,"Particular",0,0,1,0,0]
["DSCTO MARCAS",null,null,null,null,null,null,{"$f":"IF(F11=\"\",\"\",VLOOKUP(F11,CIUDADESYDEP,2,FALSE))","v":""},null,0,0,0,0,null,0,{"$f":"I11*O11/100","v":0},1,0,0]
[5,null,null,null,null,"PEREIRA",null,{"$f":"IF(F12=\"\",\"\",VLOOKUP(F12,CIUDADESYDEP,2,FALSE))","v":"RISARALDA"},null,null,null,null,null,null,0,0,1,0,0]
["MAZDA",null,null,null,null,null,null,{"$f":"IF(F13=\"\",\"\",VLOOKUP(F13,CIUDADESYDEP,2,FALSE))","v":""}]
["FORD",null,null,null,null,null,null,{"$f":"IF(F14=\"\",\"\",VLOOKUP(F14,CIUDADESYDEP,2,FALSE))","v":""}]
["SEMAFORIZACION",null,null,null,null,null,null,{"$f":"IF(F15=\"\",\"\",VLOOKUP(F15,CIUDADESYDEP,2,FALSE))","v":""}]
[1,null,null,null,null,null,null,{"$f":"IF(F16=\"\",\"\",VLOOKUP(F16,CIUDADESYDEP,2,FALSE))","v":""}]
[2,null,null,null,null,null,null,{"$f":"IF(F17=\"\",\"\",VLOOKUP(F17,CIUDADESYDEP,2,FALSE))","v":""}]
[3,null,null,null,null,null,null,{"$f":"IF(F18=\"\",\"\",VLOOKUP(F18,CIUDADESYDEP,2,FALSE))","v":""}]
[10000000,null,null,null,null,null,null,{"$f":"IF(F19=\"\",\"\",VLOOKUP(F19,CIUDADESYDEP,2,FALSE))","v":""}]
[20000000,null,null,null,null,null,null,{"$f":"IF(F20=\"\",\"\",VLOOKUP(F20,CIUDADESYDEP,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F21=\"\",\"\",VLOOKUP(F21,CIUDADESYDEP,2,FALSE))","v":""}]

{"sheet":"TABLAS","index":3,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["CIUDAD","DEPTO",null,"MARCA",null,"MODALIDAD"]
["PEREIRA","RISARALDA",null,"FORD",null,"Público"]
["ARMENIA","QUINDIO",null,"MAZDA",null,"Particular"]
["MANIZALES","CALDAS",null,"RENAULT"]
["CARTAGO","VALLE",null,"CHEVROLET"]
["DOSQUEBRADAS","RISARALDA",null,"AUDI"]

{"sheet":"ENUNCIADO","index":4,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["TIENEN IVA TODOS LOS VEHICULOS QUE EL PRECIO SEA MAYOR A 15,000,000"]
[]
["TIENEN RETENCION TODOS LOS VEHICULOS QUE SEAN DE LA CIUDAD DE PEREIRA"]
[]
["TIENEN DESCUENTO DEL 5% TODAS LAS MARCAS QUE SEAN MAZDA O FORD"]
[]
["PRECIO VENTA","SEMAFORIZACION"]
["0 - 10,000,000",0.01]
["10,000,001 Y 20,000,000",0.02]
["SUPERIORES",0.03]
[]
["COLOCAR FORMATO CONDICIONAL EN EL DEPARTAMENTO: COLOR ROJO Y FONDO AMARILLO PARA LOS"]
["QUE SEAN DE RISARALDA"]
["FORMATEAR LA COLUMNA DE PRECIO CON UN COLOR QUE MUESTRE DIFERENCIA DE PRECIOS"]
["COLOCAR FUENTE DE COLOR ROJO Y EN NEGRITA PARA LOS PRECIOS QUE ESTEN ENTRE 30.000.000 Y 60.000.000"]

{"sheet":"Hoja1","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}